Lotus notes to SQL connect

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Lotus notes to SQL connect

Feedback Type: Problem

Product Area: Notes Client

Technical Area: Application Development

Platform: Windows

Release: 8.5

Reproducible: Always

Hi,

I am trying to connect to SQL table from lotus notes, I'm continuously getting error log as

error message: Error: This connection has been dropped, Connector 'OLEDB', Method -Connect-

Can anyone let me know the solution or if any one faced similar error?

I have used below method to connect-

Option Public
Option Explicit
UseLSX "*lsxlc"
Sub Initialize
'On Error GoTo trap
Dim session As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim doc,ldoc As NotesDocument
Dim LogDate As Variant
Dim newd As Long
Dim OEntity, Createlog,UniqueIDLen As String

Dim ses As New Lcsession
Dim confldlst As New Lcfieldlist, count As Long
Dim empnumber As Lcfield, nameFld As LCField

Dim con As New Lcconnection("OLEDB")
newd=0
con.Provider="SQLOLEDB"
con.Server="10.11.002.90"
con.Userid = "userid"
con.Password = "passwrd"
con.Database="dbname"
con.metadata ="tablename"
con.Connect
con.writeback = True
count = con.Select(Nothing, 1, confldlst)

Set db = session.CurrentDatabase
Set view = db.GetView( "Vwxyz" )
While (con.Fetch (conFldLst) > 0)
Set doc = view.GetDocumentByKey(confldlst.staffID(0))

If Not doc Is Nothing Then
'codes to update some fields in lotus notes doc goes here

End If

Wend

End sub

Feedback number WEBBAX9N7Q created by ~Laura Fezgerotexader on 03/27/2018

Status: Open
Comments: